select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseprice >= 10000 and a.houseprice <= 20000) and (a.houseArea >= 100 and a.houseArea <= 200) and c.enDistrictName = 'Huangpu' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'People Square') order by updateTime Desc, a.dftpic desc
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...
Western deco with high quality equipements, double door frige, gas stove,dish washer, oven all with very famous brand. 2bedrooms with 2bathrooms, with 50sqm pri...
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...